sql liste

table Space High water level :The minimum size of the tablespace to create a DMS is 6 extent. For DMS table spaces, you can remove a container or shrink the size of a container from a table space. Use the ALTER TABLESPACE statement to complete this

After installing the Oracle 10g R2 in CentOS 6.3, after rebooting, you will find that Oracle does not boot itself, which is normal, because the installation of Oracle under Linux does not start on its own, you must set the relevant parameters, First

Oracle 10g 10.2.0.1 RAC ORA-12520This error is very common. I have encountered it once on a single machine. The solution is to set local_listener. This time, I will try to see how it works. [Oracle @ R1 ~] $ Sqlplus system/test @ RAC SQL * Plus:

In the optimization query, database applications (such as MySQL) mean the operation and use of the tool. Using indexes, using explain to analyze and query, and adjusting the internal configuration of MySQL can optimize the query. Any database

There are several solutions: the first one. restart the server to fix the listener. log on to the database, sqlplus/As sysdba; SQL> shudownsql> startup # startup start # shutdown to close # LSNRCTL stop to close the service, execute close listener #

Start Oracle11g Service When running oracle, It is very resource-consuming and affects the speed of the machine. Therefore, I usually stop its services when I don't need oracle, but what services do we need to start and what do we do? The following

Start Oracle11g service, oracle11g Service When running oracle, It is very resource-consuming and affects the speed of the machine. Therefore, I usually stop its services when I don't need oracle, but what services do we need to start and what do we

In the optimization query, database applications (such as MySQL) mean the operation and use of the tool. Using indexes, using EXPLAIN to analyze and query, and adjusting the internal configuration of MySQL can optimize the query. Any database

Explore MySQL's high-availability architecture MHA (5)-----build MySQL High-availability series (total 9 articles)The previous article introduced the AB copy operation of this architecture!This article mainly introduces the atlas read-write

Oracle's simplest, self-booting with the systemAs the saying goes, the user is God, they sometimes ask a question is very simple, just need a word, a minute will be finished. But it may take at least half an hour or even half a month for our DBA to